/ PC Plus SuperCD (UK) 1995 August / PC Plus Super CD (Issue 106) (PCP106) (August 1995).iso / ability / disk5 / func_ref.dh_ / func_ref.dh

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 03 00 3a 00 ff ff 01 00 | 08 00 43 4e 61 76 49 74 |..:.....|..CNavIt|
|00000010| 65 6d 12 42 75 69 6c 74 | 2d 69 6e 20 46 75 6e 63 |em.Built|-in Func|
|00000020| 74 69 6f 6e 73 00 00 00 | 00 00 00 01 00 01 00 00 |tions...|........|
|00000030| 00 00 00 01 80 07 47 65 | 6e 65 72 61 6c 00 09 47 |......Ge|neral..G|
|00000040| 65 6e 65 72 61 6c 2e 32 | 02 00 00 00 02 00 02 00 |eneral.2|........|
|00000050| 01 00 00 00 01 80 0f 44 | 61 74 65 20 46 75 6e 63 |.......D|ate Func|
|00000060| 74 69 6f 6e 73 2e 00 10 | 44 61 74 65 46 75 6e 63 |tions...|DateFunc|
|00000070| 74 69 6f 6e 73 2e 2e 33 | 03 00 00 00 02 00 02 00 |tions..3|........|
|00000080| 02 00 00 00 01 80 16 44 | 41 54 45 28 79 65 61 72 |.......D|ATE(year|
|00000090| 2c 20 6d 6f 6e 74 68 2c | 20 64 61 79 29 00 16 44 |, month,| day)..D|
|000000a0| 41 54 45 2e 79 65 61 72 | 2e 6d 6f 6e 74 68 2e 64 |ATE.year|.month.d|
|000000b0| 61 79 2e 2e 34 04 00 00 | 00 03 00 03 00 03 00 00 |ay..4...|........|
|000000c0| 00 01 80 0e 44 41 59 28 | 64 61 74 65 2d 63 6f 64 |....DAY(|date-cod|
|000000d0| 65 29 00 10 44 41 59 2e | 64 61 74 65 2e 63 6f 64 |e)..DAY.|date.cod|
|000000e0| 65 2e 2e 35 05 00 00 00 | 03 00 03 00 04 00 00 00 |e..5....|........|
|000000f0| 01 80 10 4d 4f 4e 54 48 | 28 64 61 74 65 2d 63 6f |...MONTH|(date-co|
|00000100| 64 65 29 00 12 4d 4f 4e | 54 48 2e 64 61 74 65 2e |de)..MON|TH.date.|
|00000110| 63 6f 64 65 2e 2e 36 06 | 00 00 00 03 00 03 00 05 |code..6.|........|
|00000120| 00 00 00 01 80 08 54 4f | 44 41 59 28 20 29 00 09 |......TO|DAY( )..|
|00000130| 54 4f 44 41 59 2e 2e 2e | 37 07 00 00 00 03 00 03 |TODAY...|7.......|
|00000140| 00 06 00 00 00 01 80 12 | 57 45 45 4b 44 41 59 28 |........|WEEKDAY(|
|00000150| 64 61 74 65 2d 63 6f 64 | 65 29 00 14 57 45 45 4b |date-cod|e)..WEEK|
|00000160| 44 41 59 2e 64 61 74 65 | 2e 63 6f 64 65 2e 2e 38 |DAY.date|.code..8|
|00000170| 08 00 00 00 03 00 03 00 | 07 00 00 00 01 80 0e 59 |........|.......Y|
|00000180| 45 41 52 28 64 61 74 65 | 63 6f 64 65 29 00 10 59 |EAR(date|code)..Y|
|00000190| 45 41 52 2e 64 61 74 65 | 63 6f 64 65 2e 2e 39 09 |EAR.date|code..9.|
|000001a0| 00 00 00 03 00 03 00 08 | 00 00 00 01 80 13 46 69 |........|......Fi|
|000001b0| 6e 61 6e 63 69 61 6c 20 | 46 75 6e 63 74 69 6f 6e |nancial |Function|
|000001c0| 73 00 15 46 69 6e 61 6e | 63 69 61 6c 46 75 6e 63 |s..Finan|cialFunc|
|000001d0| 74 69 6f 6e 73 2e 31 30 | 0a 00 00 00 02 00 02 00 |tions.10|........|
|000001e0| 09 00 00 00 01 80 27 43 | 4f 4d 50 4f 55 4e 44 20 |......'C|OMPOUND |
|000001f0| 28 70 72 69 6e 63 69 70 | 61 6c 2c 20 69 6e 74 65 |(princip|al, inte|
|00000200| 72 65 73 74 2c 20 70 65 | 72 69 6f 64 73 29 00 27 |rest, pe|riods).'|
|00000210| 43 4f 4d 50 4f 55 4e 44 | 2e 70 72 69 6e 63 69 70 |COMPOUND|.princip|
|00000220| 61 6c 2e 69 6e 74 65 72 | 65 73 74 2e 70 65 72 69 |al.inter|est.peri|
|00000230| 6f 64 73 2e 2e 31 31 0b | 00 00 00 03 00 03 00 0a |ods..11.|........|
|00000240| 00 00 00 01 80 1a 46 56 | 28 70 61 79 6d 65 6e 74 |......FV|(payment|
|00000250| 2c 20 72 61 74 65 2c 20 | 70 65 72 69 6f 64 73 29 |, rate, |periods)|
|00000260| 00 1b 46 56 2e 70 61 79 | 6d 65 6e 74 2e 72 61 74 |..FV.pay|ment.rat|
|00000270| 65 2e 70 65 72 69 6f 64 | 73 2e 2e 31 32 0c 00 00 |e.period|s..12...|
|00000280| 00 03 00 03 00 0b 00 00 | 00 01 80 10 49 52 52 28 |........|....IRR(|
|00000290| 67 75 65 73 73 2c 20 6c | 69 73 74 29 00 12 49 52 |guess, l|ist)..IR|
|000002a0| 52 2e 67 75 65 73 73 2e | 6c 69 73 74 2e 2e 31 33 |R.guess.|list..13|
|000002b0| 0d 00 00 00 03 00 03 00 | 0c 00 00 00 01 80 0f 4e |........|.......N|
|000002c0| 50 56 28 72 61 74 65 2c | 20 6c 69 73 74 29 00 11 |PV(rate,| list)..|
|000002d0| 4e 50 56 2e 72 61 74 65 | 2e 6c 69 73 74 2e 2e 31 |NPV.rate|.list..1|
|000002e0| 34 0e 00 00 00 03 00 03 | 00 0d 00 00 00 01 80 1d |4.......|........|
|000002f0| 50 4d 54 28 70 72 69 6e | 63 69 70 61 6c 2c 20 72 |PMT(prin|cipal, r|
|00000300| 61 74 65 2c 20 70 65 72 | 69 6f 64 73 29 00 1e 50 |ate, per|iods)..P|
|00000310| 4d 54 2e 70 72 69 6e 63 | 69 70 61 6c 2e 72 61 74 |MT.princ|ipal.rat|
|00000320| 65 2e 70 65 72 69 6f 64 | 73 2e 2e 31 35 0f 00 00 |e.period|s..15...|
|00000330| 00 03 00 03 00 0e 00 00 | 00 01 80 1a 50 56 28 70 |........|....PV(p|
|00000340| 61 79 6d 65 6e 74 2c 20 | 72 61 74 65 2c 20 70 65 |ayment, |rate, pe|
|00000350| 72 69 6f 64 73 29 00 1b | 50 56 2e 70 61 79 6d 65 |riods)..|PV.payme|
|00000360| 6e 74 2e 72 61 74 65 2e | 70 65 72 69 6f 64 73 2e |nt.rate.|periods.|
|00000370| 2e 31 36 10 00 00 00 03 | 00 03 00 0f 00 00 00 01 |.16.....|........|
|00000380| 80 11 4c 6f 67 69 63 61 | 6c 20 46 75 6e 63 74 69 |..Logica|l Functi|
|00000390| 6f 6e 73 00 13 4c 6f 67 | 69 63 61 6c 46 75 6e 63 |ons..Log|icalFunc|
|000003a0| 74 69 6f 6e 73 2e 31 37 | 11 00 00 00 02 00 02 00 |tions.17|........|
|000003b0| 10 00 00 00 01 80 12 49 | 46 28 78 2c 20 74 72 75 |.......I|F(x, tru|
|000003c0| 65 2c 20 66 61 6c 73 65 | 29 00 13 49 46 2e 78 2e |e, false|)..IF.x.|
|000003d0| 74 72 75 65 2e 66 61 6c | 73 65 2e 2e 31 38 12 00 |true.fal|se..18..|
|000003e0| 00 00 03 00 03 00 11 00 | 00 00 01 80 0b 49 53 45 |........|.....ISE|
|000003f0| 52 52 28 6c 69 73 74 29 | 00 0e 49 53 45 52 52 2e |RR(list)|..ISERR.|
|00000400| 6c 69 73 74 2e 2e 31 39 | 13 00 00 00 03 00 03 00 |list..19|........|
|00000410| 12 00 00 00 01 80 16 4d | 61 74 68 65 6d 61 74 69 |.......M|athemati|
|00000420| 63 61 6c 20 46 75 6e 63 | 74 69 6f 6e 73 00 18 4d |cal Func|tions..M|
|00000430| 61 74 68 65 6d 61 74 69 | 63 61 6c 46 75 6e 63 74 |athemati|calFunct|
|00000440| 69 6f 6e 73 2e 32 30 14 | 00 00 00 02 00 02 00 13 |ions.20.|........|
|00000450| 00 00 00 01 80 06 41 42 | 53 28 78 29 00 09 41 42 |......AB|S(x)..AB|
|00000460| 53 2e 78 2e 2e 32 31 15 | 00 00 00 03 00 03 00 14 |S.x..21.|........|
|00000470| 00 00 00 01 80 1a 41 56 | 45 52 41 47 45 28 6c 69 |......AV|ERAGE(li|
|00000480| 73 74 29 20 6f 72 20 41 | 56 47 28 6c 69 73 74 29 |st) or A|VG(list)|
|00000490| 00 1b 41 56 45 52 41 47 | 45 2e 6c 69 73 74 2e 6f |..AVERAG|E.list.o|
|000004a0| 72 41 56 47 2e 6c 69 73 | 74 2e 2e 32 32 16 00 00 |rAVG.lis|t..22...|
|000004b0| 00 03 00 03 00 15 00 00 | 00 01 80 0a 43 4f 4d 42 |........|....COMB|
|000004c0| 28 6e 2c 20 6d 29 00 0c | 43 4f 4d 42 2e 6e 2e 6d |(n, m)..|COMB.n.m|
|000004d0| 2e 2e 32 33 17 00 00 00 | 03 00 03 00 16 00 00 00 |..23....|........|
|000004e0| 01 80 0b 43 4f 55 4e 54 | 28 6c 69 73 74 29 00 0e |...COUNT|(list)..|
|000004f0| 43 4f 55 4e 54 2e 6c 69 | 73 74 2e 2e 32 34 18 00 |COUNT.li|st..24..|
|00000500| 00 00 03 00 03 00 17 00 | 00 00 01 80 06 45 58 50 |........|.....EXP|
|00000510| 28 78 29 00 09 45 58 50 | 2e 78 2e 2e 32 35 19 00 |(x)..EXP|.x..25..|
|00000520| 00 00 03 00 03 00 18 00 | 00 00 01 80 07 46 41 43 |........|.....FAC|
|00000530| 54 28 6e 29 00 0a 46 41 | 43 54 2e 6e 2e 2e 32 36 |T(n)..FA|CT.n..26|
|00000540| 1a 00 00 00 03 00 03 00 | 19 00 00 00 01 80 06 49 |........|.......I|
|00000550| 4e 54 28 78 29 00 09 49 | 4e 54 2e 78 2e 2e 32 37 |NT(x)..I|NT.x..27|
|00000560| 1b 00 00 00 03 00 03 00 | 1a 00 00 00 01 80 05 4c |........|.......L|
|00000570| 4e 28 78 29 00 08 4c 4e | 2e 78 2e 2e 32 38 1c 00 |N(x)..LN|.x..28..|
|00000580| 00 00 03 00 03 00 1b 00 | 00 00 01 80 06 4c 4f 47 |........|.....LOG|
|00000590| 28 78 29 00 09 4c 4f 47 | 2e 78 2e 2e 32 39 1d 00 |(x)..LOG|.x..29..|
|000005a0| 00 00 03 00 03 00 1c 00 | 00 00 01 80 09 4d 41 58 |........|.....MAX|
|000005b0| 28 6c 69 73 74 29 00 0c | 4d 41 58 2e 6c 69 73 74 |(list)..|MAX.list|
|000005c0| 2e 2e 33 30 1e 00 00 00 | 03 00 03 00 1d 00 00 00 |..30....|........|
|000005d0| 01 80 09 4d 49 4e 28 6c | 69 73 74 29 00 0c 4d 49 |...MIN(l|ist)..MI|
|000005e0| 4e 2e 6c 69 73 74 2e 2e | 33 31 1f 00 00 00 03 00 |N.list..|31......|
|000005f0| 03 00 1e 00 00 00 01 80 | 09 4d 4f 44 28 78 2c 20 |........|.MOD(x, |
|00000600| 79 29 00 0b 4d 4f 44 2e | 78 2e 79 2e 2e 33 32 20 |y)..MOD.|x.y..32 |
|00000610| 00 00 00 03 00 03 00 1f | 00 00 00 01 80 0a 50 45 |........|......PE|
|00000620| 52 4d 28 6e 2c 20 6d 29 | 00 0c 50 45 52 4d 2e 6e |RM(n, m)|..PERM.n|
|00000630| 2e 6d 2e 2e 33 33 21 00 | 00 00 03 00 03 00 20 00 |.m..33!.|...... .|
|00000640| 00 00 01 80 07 52 41 4e | 44 28 78 29 00 0a 52 41 |.....RAN|D(x)..RA|
|00000650| 4e 44 2e 78 2e 2e 33 34 | 22 00 00 00 03 00 03 00 |ND.x..34|".......|
|00000660| 21 00 00 00 01 80 0b 52 | 4f 55 4e 44 28 78 2c 20 |!......R|OUND(x, |
|00000670| 79 29 00 0d 52 4f 55 4e | 44 2e 78 2e 79 2e 2e 33 |y)..ROUN|D.x.y..3|
|00000680| 35 23 00 00 00 03 00 03 | 00 22 00 00 00 01 80 07 |5#......|."......|
|00000690| 53 51 52 54 28 78 29 00 | 0a 53 51 52 54 2e 78 2e |SQRT(x).|.SQRT.x.|
|000006a0| 2e 33 36 24 00 00 00 03 | 00 03 00 23 00 00 00 01 |.36$....|...#....|
|000006b0| 80 09 53 54 44 28 6c 69 | 73 74 29 00 0c 53 54 44 |..STD(li|st)..STD|
|000006c0| 2e 6c 69 73 74 2e 2e 33 | 37 25 00 00 00 03 00 03 |.list..3|7%......|
|000006d0| 00 24 00 00 00 01 80 09 | 53 55 4d 28 6c 69 73 74 |.$......|SUM(list|
|000006e0| 29 00 0c 53 55 4d 2e 6c | 69 73 74 2e 2e 33 38 26 |)..SUM.l|ist..38&|
|000006f0| 00 00 00 03 00 03 00 25 | 00 00 00 01 80 0b 54 4f |.......%|......TO|
|00000700| 54 41 4c 28 6c 69 73 74 | 29 00 0e 54 4f 54 41 4c |TAL(list|)..TOTAL|
|00000710| 2e 6c 69 73 74 2e 2e 33 | 39 27 00 00 00 03 00 03 |.list..3|9'......|
|00000720| 00 26 00 00 00 01 80 09 | 56 41 52 28 6c 69 73 74 |.&......|VAR(list|
|00000730| 29 00 0c 56 41 52 2e 6c | 69 73 74 2e 2e 34 30 28 |)..VAR.l|ist..40(|
|00000740| 00 00 00 03 00 03 00 27 | 00 00 00 01 80 14 57 41 |.......'|......WA|
|00000750| 56 47 28 72 61 6e 67 65 | 31 2c 20 72 61 6e 67 65 |VG(range|1, range|
|00000760| 32 29 00 16 57 41 56 47 | 2e 72 61 6e 67 65 31 2e |2)..WAVG|.range1.|
|00000770| 72 61 6e 67 65 32 2e 2e | 34 31 29 00 00 00 03 00 |range2..|41).....|
|00000780| 03 00 28 00 00 00 01 80 | 17 54 72 69 67 6f 6e 6f |..(.....|.Trigono|
|00000790| 6d 65 74 72 69 63 20 46 | 75 6e 63 74 69 6f 6e 73 |metric F|unctions|
|000007a0| 00 19 54 72 69 67 6f 6e | 6f 6d 65 74 72 69 63 46 |..Trigon|ometricF|
|000007b0| 75 6e 63 74 69 6f 6e 73 | 2e 34 32 2a 00 00 00 02 |unctions|.42*....|
|000007c0| 00 02 00 29 00 00 00 01 | 80 07 41 43 4f 53 28 78 |...)....|..ACOS(x|
|000007d0| 29 00 0a 41 43 4f 53 2e | 78 2e 2e 34 33 2b 00 00 |)..ACOS.|x..43+..|
|000007e0| 00 03 00 03 00 2a 00 00 | 00 01 80 07 41 53 49 4e |.....*..|....ASIN|
|000007f0| 28 78 29 00 0a 41 53 49 | 4e 2e 78 2e 2e 34 34 2c |(x)..ASI|N.x..44,|
|00000800| 00 00 00 03 00 03 00 2b | 00 00 00 01 80 07 41 54 |.......+|......AT|
|00000810| 41 4e 28 78 29 00 0a 41 | 54 41 4e 2e 78 2e 2e 34 |AN(x)..A|TAN.x..4|
|00000820| 35 2d 00 00 00 03 00 03 | 00 2c 00 00 00 01 80 0b |5-......|.,......|
|00000830| 41 54 41 4e 32 28 78 2c | 20 79 29 00 0d 41 54 41 |ATAN2(x,| y)..ATA|
|00000840| 4e 32 2e 78 2e 79 2e 2e | 34 36 2e 00 00 00 03 00 |N2.x.y..|46......|
|00000850| 03 00 2d 00 00 00 01 80 | 06 43 4f 53 28 78 29 00 |..-.....|.COS(x).|
|00000860| 09 43 4f 53 2e 78 2e 2e | 34 37 2f 00 00 00 03 00 |.COS.x..|47/.....|
|00000870| 03 00 2e 00 00 00 01 80 | 04 50 49 28 29 00 07 50 |........|.PI()..P|
|00000880| 49 2e 2e 2e 34 38 30 00 | 00 00 03 00 03 00 2f 00 |I...480.|....../.|
|00000890| 00 00 01 80 06 53 49 4e | 28 78 29 00 09 53 49 4e |.....SIN|(x)..SIN|
|000008a0| 2e 78 2e 2e 34 39 31 00 | 00 00 03 00 03 00 30 00 |.x..491.|......0.|
|000008b0| 00 00 01 80 06 54 41 4e | 28 78 29 00 09 54 41 4e |.....TAN|(x)..TAN|
|000008c0| 2e 78 2e 2e 35 30 32 00 | 00 00 03 00 03 00 31 00 |.x..502.|......1.|
|000008d0| 00 00 01 80 10 4c 6f 6f | 6b 75 70 20 46 75 6e 63 |.....Loo|kup Func|
|000008e0| 74 69 6f 6e 73 00 12 4c | 6f 6f 6b 75 70 46 75 6e |tions..L|ookupFun|
|000008f0| 63 74 69 6f 6e 73 2e 35 | 31 33 00 00 00 02 00 02 |ctions.5|13......|
|00000900| 00 32 00 00 00 01 80 11 | 46 49 4e 44 28 76 61 6c |.2......|FIND(val|
|00000910| 75 65 2c 20 6c 69 73 74 | 29 00 13 46 49 4e 44 2e |ue, list|)..FIND.|
|00000920| 76 61 6c 75 65 2e 6c 69 | 73 74 2e 2e 35 32 34 00 |value.li|st..524.|
|00000930| 00 00 03 00 03 00 33 00 | 00 00 01 80 0e 49 4e 44 |......3.|.....IND|
|00000940| 45 58 28 78 2c 20 6c 69 | 73 74 29 00 10 49 4e 44 |EX(x, li|st)..IND|
|00000950| 45 58 2e 78 2e 6c 69 73 | 74 2e 2e 35 33 35 00 00 |EX.x.lis|t..535..|
|00000960| 00 03 00 03 00 34 00 00 | 00 01 80 1d 4c 4f 4f 4b |.....4..|....LOOK|
|00000970| 55 50 28 78 2c 20 69 6e | 2d 72 61 6e 67 65 2c 20 |UP(x, in|-range, |
|00000980| 6f 75 74 72 61 6e 67 65 | 29 00 1e 4c 4f 4f 4b 55 |outrange|)..LOOKU|
|00000990| 50 2e 78 2e 69 6e 2e 72 | 61 6e 67 65 2e 6f 75 74 |P.x.in.r|ange.out|
|000009a0| 72 61 6e 67 65 2e 2e 35 | 34 36 00 00 00 03 00 03 |range..5|46......|
|000009b0| 00 35 00 00 00 01 80 09 | 4f 70 65 72 61 74 6f 72 |.5......|Operator|
|000009c0| 73 00 0c 4f 70 65 72 61 | 74 6f 72 73 2e 35 35 37 |s..Opera|tors.557|
|000009d0| 00 00 00 02 00 02 00 36 | 00 00 00 01 80 16 4d 61 |.......6|......Ma|
|000009e0| 74 68 65 6d 61 74 69 63 | 61 6c 20 4f 70 65 72 61 |thematic|al Opera|
|000009f0| 74 6f 72 73 00 18 4d 61 | 74 68 65 6d 61 74 69 63 |tors..Ma|thematic|
|00000a00| 61 6c 4f 70 65 72 61 74 | 6f 72 73 2e 35 36 38 00 |alOperat|ors.568.|
|00000a10| 00 00 03 00 03 00 37 00 | 00 00 01 80 11 4c 6f 67 |......7.|.....Log|
|00000a20| 69 63 61 6c 20 4f 70 65 | 72 61 74 6f 72 73 00 13 |ical Ope|rators..|
|00000a30| 4c 6f 67 69 63 61 6c 4f | 70 65 72 61 74 6f 72 73 |LogicalO|perators|
|00000a40| 2e 35 37 39 00 00 00 03 | 00 03 00 38 00 00 00 01 |.579....|...8....|
|00000a50| 80 14 52 65 6c 61 74 69 | 6f 6e 61 6c 20 4f 70 65 |..Relati|onal Ope|
|00000a60| 72 61 74 6f 72 73 00 16 | 52 65 6c 61 74 69 6f 6e |rators..|Relation|
|00000a70| 61 6c 4f 70 65 72 61 74 | 6f 72 73 2e 35 38 3a 00 |alOperat|ors.58:.|
|00000a80| 00 00 03 00 03 00 39 00 | 00 00 27 02 03 00 fe 03 |......9.|..'.....|
|00000a90| f2 02 1a 41 62 69 6c 69 | 74 79 20 46 75 6e 63 74 |...Abili|ty Funct|
|00000aa0| 69 6f 6e 20 52 65 66 65 | 72 65 6e 63 65 00 00 00 |ion Refe|rence...|
|00000ab0| 00 ff ff e8 00 00 00 01 | 00 00 00 01 00 01 00 01 |........|........|
|00000ac0| 00 01 00 00 00 00 00 05 | 41 72 69 61 6c 00 00 1c |........|Arial...|
|00000ad0| 41 0c 46 55 4e 43 5f 52 | 45 46 2e 48 4c 50 00 00 |A.FUNC_R|EF.HLP..|
|00000ae0| 01 00 00 00 0a 26 4e 61 | 76 69 67 61 74 6f 72 03 |.....&Na|vigator.|
|00000af0| 26 55 70 01 00 01 00 01 | 00 01 00 00 00 01 00 01 |&Up.....|........|
|00000b00| 00 01 00 01 00 01 00 01 | 00 01 00 00 00 00 00 01 |........|........|
|00000b10| 00 01 00 01 00 01 00 01 | 00 00 00 00 00 01 00 01 |........|........|
|00000b20| 00 01 00 01 00 00 00 01 | 00 00 00 00 00          |........|.....   |
+--------+-------------------------+-------------------------+--------+--------+